delete from sm_appregister where PK_APPREGISTER='1001ZZ100000000TPBGY' 
go

delete from sm_appmenuitem where PK_MENUITEM='1001ZZ100000000TPBGZ' 
go

insert into sm_appmenuitem ( PK_MENU,RESID,MENUITEMNAME,APPID,APPCODE,MENUDES,MENUITEMCODE,APP_IMAGE,PARENTCODE,IMAGE_SRC,PK_GROUP,IS_CLOUD_APP,MENUORDER,PK_MENUITEM,FLOOR,DR,TS ) values  ( '1004Z510000000000FFL',null,'凭证对照关系','1001ZZ100000000TPBGY','20020COAMP',null,'20021035',null,'200210',null,null,null,null,'1001ZZ100000000TPBGZ',null,0,'2023-04-14 12:11:39' ) 
go

insert into sm_appregister ( FASTLAUNCHPAGECODE,SCOPEID,NAME,RESID,TARGET_PATH,PAGERESFILE,ISENABLE,MDID,OWN_MODULE,CODE,CREATIONTIME,FASTLAUNCHURL,APPTYPE,FASTLAUNCHPARAM,IMAGE_SRC,APP_DESC,CREATOR,SOURCE_APP_CODE,FUN_PROPERTY,FUNTYPE,HELP_NAME,ISCAUSERUSABLE,PK_GROUP,HEIGHT,MOUNTID,WIDTH,ISCOPYPAGE,USELICENSE_LOAD,ORGTYPECODE,MODIFIER,PARENT_ID,MODIFIEDTIME,PK_APPREGISTER,DR,TS ) values  ( null,null,'凭证对照关系',null,null,null,'Y','9f71d037-03f1-4218-811d-d57672d4ccd3','2002','20020COAMP','2023-04-14 12:11:36',null,1,null,'default',null,'1001ZZ1000000009QV6F','20020COAMP',0,0,null,'N',null,1,null,1,'N','Y','GLOBLE00000000000000',null,'0001Z3100000000252Q0',null,'1001ZZ100000000TPBGY',0,'2023-04-14 12:11:38' ) 
go

insert into sm_apppage ( PAGERESFILE,MODIFIER,CREATOR,ISCARDDEFAULT,CREATIONTIME,PAGEDESC,PK_APPPAGE,ISDEFAULT,PAGECODE,RESID,PAGEURL,MODIFIEDTIME,TRANSFERSIGN,PAGEJSURL,PARENTCODE,ISNEWPAGE,PARENT_ID,PAGENAME,MOBPAGERESFILE,STYLETYPE,DR,TS ) values  ( null,null,null,null,null,null,'1001ZZ1LCP00000TPBH1','Y','20020COAMP_Coamap',null,'/nccloud/resources/gl/coamap/coamap/main/index.html',null,null,null,'20020COAMP',null,'1001ZZ100000000TPBGY','凭证对照关系',null,null,0,'2023-04-14 12:11:42' ) 
go

insert into pub_page_templet ( NAME,CREATIONTIME,PARENTID,CLAZZ,PK_GROUP,PAGECODE,PAGESTYLE,APPCODE,CODE,MODIFIEDTIME,HEADCODE,LAYOUT,METAID,ISDEFAULT,PK_PAGE_TEMPLET,RESID,CREATOR,APPID,PK_ORG,MODIFIER,TEMPLETDESC,RESMODULE,DR,TS ) values  ( '凭证对照关系',null,'root','nc.vo.gl.coamap.CoamapVO',null,'20020COAMP_Coamap',null,'20020COAMP','20020COAMP_Coamap',null,'CoamapTable',null,'9f71d037-03f1-4218-811d-d57672d4ccd3','Y','1001ZZ1LCP00000TPBH2',null,null,null,null,null,null,null,0,'2023-04-14 12:11:42' ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@',null,null,'Y','Y',null,null,204,'业务单元(所有)','pk_org','9f71d037-03f1-4218-811d-d57672d4ccd3','Y',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=','pk_org',null,null,null,'N',null,'0001Z01000000001V021,code=N','Y',null,null,120,null,'693c2c7c-104b-4aec-b88a-e65f49997cbd',null,null,null,'N',null,null,null,'N','N','N',null,1,null,'组织','uap.org.name','N','N','1001ZZ1LCP00000TPBH5',null,null,null,'Y',20,null,null,'refer','uapbd/refer/org/BusinessUnitAllTreeRef/index',0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','Y',null,null,1,null,'code','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','code',null,null,null,'N',null,null,'Y',null,null,120,null,'8fbe6dbd-8582-4bc2-a5f8-32c8f382d22c',null,null,null,'N',null,null,null,'N','N','N',null,2,null,'code',null,'N','N','1001ZZ1LCP00000TPBH6',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','Y',null,null,1,null,'name','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','name',null,null,null,'N',null,null,'Y',null,null,120,null,'407b5113-a309-454a-a57a-381b19ce4806',null,null,null,'N',null,null,null,'N','N','N',null,3,null,'name',null,'N','N','1001ZZ1LCP00000TPBH7',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@不等于@',null,null,'Y','Y',null,null,203,null,'enablestate','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@<>@','enablestate',null,null,null,'N',null,'未启用=1,已启用=2,已停用=3','Y',null,null,120,null,'b339f122-57d3-471e-a191-901f5c456cb5',null,'未启用=1,已启用=2,已停用=3',null,'N',null,null,null,'N','N','N',null,4,null,'启用标记',null,'N','N','1001ZZ1LCP00000TPBH8',null,null,null,'Y',50,null,null,'select',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def12','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def12',null,null,null,'N',null,null,'Y',null,null,120,null,'0317ff9e-daaa-4d03-9952-00359cf2c192',null,null,null,'Y',null,null,null,'N','N','N',null,1,null,'自定义项12',null,'N','N','1001ZZ1LCP00000TPBH9',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipbank','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipbank',null,null,null,'N',null,null,'Y',null,null,120,null,'11aa98e0-8acd-449b-b932-219c5e012313',null,null,null,'N',null,null,null,'N','N','N',null,2,null,'BIP银行账户',null,'N','N','1001ZZ1LCP00000TPBHA',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipdept','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipdept',null,null,null,'N',null,null,'Y',null,null,120,null,'12c288f8-9334-4c69-8719-2655b2db2318',null,null,null,'N',null,null,null,'N','N','N',null,3,null,'BIP部门',null,'N','N','1001ZZ1LCP00000TPBHB',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@',null,null,'Y','N',null,null,204,'集团(所有)','pk_group','9f71d037-03f1-4218-811d-d57672d4ccd3','Y',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=','pk_group',null,null,null,'N',null,'0001Z01000000001V008,code=N','Y',null,null,120,null,'13023293-fdaf-48f2-b0b3-3d56c071dae4',null,null,null,'N',null,null,null,'N','N','N',null,4,null,'集团','uap.group.name','N','N','1001ZZ1LCP00000TPBHC',null,null,null,'Y',20,null,null,'refer','uapbd/refer/org/GroupDefaultTreeRef/index',0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcsystemname','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcsystemname',null,null,null,'N',null,null,'Y',null,null,120,null,'20b41540-2fde-4c6c-8eb3-490976baea3d',null,null,null,'N',null,null,null,'N','N','N',null,5,null,'来源系统名称',null,'N','N','1001ZZ1LCP00000TPBHD',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcprop','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcprop',null,null,null,'N',null,null,'Y',null,null,120,null,'247d97fc-6f02-4f28-a96d-b8446f2e37e4',null,null,null,'N',null,null,null,'N','N','N',null,6,null,'SRC业态',null,'N','N','1001ZZ1LCP00000TPBHE',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcproj','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcproj',null,null,null,'N',null,null,'Y',null,null,120,null,'291f9f81-8221-45a9-93ec-6d8046bf7906',null,null,null,'N',null,null,null,'N','N','N',null,7,null,'SRC项目',null,'N','N','1001ZZ1LCP00000TPBHF',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srccurrency','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srccurrency',null,null,null,'N',null,null,'Y',null,null,120,null,'2c9eecf6-de6c-4c80-88e8-133b73eecc44',null,null,null,'N',null,null,null,'N','N','N',null,8,null,'SRC币种',null,'N','N','1001ZZ1LCP00000TPBHG',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','介于@等于@大于@大于等于@小于@小于等于@',null,null,'Y','N',null,null,34,null,'modifiedtime','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','between@=@>@>=@<@<=@','modifiedtime',null,null,null,'N',null,null,'Y',null,null,120,null,'2e3ea5da-88fa-4ba9-83a0-175c6078a00e',null,null,null,'N',null,null,null,'Y','N','N',null,9,null,'修改时间',null,'N','N','1001ZZ1LCP00000TPBHH',null,null,null,'Y',19,null,null,'datetimepicker',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'cdflag','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','cdflag',null,null,null,'N',null,null,'Y',null,null,120,null,'47930c77-017c-4171-84ca-f3edba0df8c9',null,null,null,'N',null,null,null,'N','N','N',null,11,null,'借贷标记',null,'N','N','1001ZZ1LCP00000TPBHI',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def7','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def7',null,null,null,'N',null,null,'Y',null,null,120,null,'5e797308-7721-428c-823c-842ed748b200',null,null,null,'Y',null,null,null,'N','N','N',null,13,null,'自定义项7',null,'N','N','1001ZZ1LCP00000TPBHJ',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def4','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def4',null,null,null,'N',null,null,'Y',null,null,120,null,'6027525f-bf3c-402b-8d47-f02af78104a7',null,null,null,'Y',null,null,null,'N','N','N',null,14,null,'自定义项4',null,'N','N','1001ZZ1LCP00000TPBHK',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcvouchertype','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcvouchertype',null,null,null,'N',null,null,'Y',null,null,120,null,'63444a46-fdc4-4770-9cf0-aa873787a5ea',null,null,null,'N',null,null,null,'N','N','N',null,15,null,'SRC凭证类别',null,'N','N','1001ZZ1LCP00000TPBHL',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def3','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def3',null,null,null,'N',null,null,'Y',null,null,120,null,'66b67a2a-a2ca-484e-88cc-695f5024c662',null,null,null,'Y',null,null,null,'N','N','N',null,16,null,'自定义项3',null,'N','N','1001ZZ1LCP00000TPBHM',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcbs','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcbs',null,null,null,'N',null,null,'Y',null,null,120,null,'72632d5d-ea3f-4d27-a4e9-9ac25f92b100',null,null,null,'N',null,null,null,'N','N','N',null,18,null,'SRC楼栋',null,'N','N','1001ZZ1LCP00000TPBHN',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipprop','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipprop',null,null,null,'N',null,null,'Y',null,null,120,null,'7b52f4b4-5ecf-4996-a7e4-75fde58dcbfb',null,null,null,'N',null,null,null,'N','N','N',null,19,null,'BIP业态',null,'N','N','1001ZZ1LCP00000TPBHO',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def2','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def2',null,null,null,'N',null,null,'Y',null,null,120,null,'81cbfbb1-304b-4e3b-b2ea-1ac9ef910f34',null,null,null,'Y',null,null,null,'N','N','N',null,20,null,'自定义项2',null,'N','N','1001ZZ1LCP00000TPBHP',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def19','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def19',null,null,null,'N',null,null,'Y',null,null,120,null,'8368ea60-a146-4b59-9798-7ed01b119bf2',null,null,null,'Y',null,null,null,'N','N','N',null,21,null,'自定义项19',null,'N','N','1001ZZ1LCP00000TPBHQ',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipcurrency','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipcurrency',null,null,null,'N',null,null,'Y',null,null,120,null,'84c8839e-be7c-4cf9-ae34-7ed93cfad424',null,null,null,'N',null,null,null,'N','N','N',null,22,null,'BIP币种',null,'N','N','1001ZZ1LCP00000TPBHR',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcinteface','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcinteface',null,null,null,'N',null,null,'Y',null,null,120,null,'89358270-b49f-49bd-9270-acc971b74617',null,null,null,'N',null,null,null,'N','N','N',null,23,null,'来源系统接口名称',null,'N','N','1001ZZ1LCP00000TPBHS',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipproj','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipproj',null,null,null,'N',null,null,'Y',null,null,120,null,'8da7b503-c64a-4abc-979b-5724f080543e',null,null,null,'N',null,null,null,'N','N','N',null,24,null,'BIP项目',null,'N','N','1001ZZ1LCP00000TPBHT',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srccompany','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srccompany',null,null,null,'N',null,null,'Y',null,null,120,null,'8e130a33-9fa0-44f7-8bf3-8f8f1b50fdf6',null,null,null,'N',null,null,null,'N','N','N',null,25,null,'SRC账簿',null,'N','N','1001ZZ1LCP00000TPBHU',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcaccount','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcaccount',null,null,null,'N',null,null,'Y',null,null,120,null,'908a3b13-06c3-480d-90a9-f7ea857fe545',null,null,null,'N',null,null,null,'N','N','N',null,27,null,'SRC会计科目',null,'N','N','1001ZZ1LCP00000TPBHV',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def5','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def5',null,null,null,'N',null,null,'Y',null,null,120,null,'917e6587-5bdf-445a-b5bd-177e4868fa7f',null,null,null,'Y',null,null,null,'N','N','N',null,28,null,'自定义项5',null,'N','N','1001ZZ1LCP00000TPBHW',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def14','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def14',null,null,null,'N',null,null,'Y',null,null,120,null,'91a62b01-e82d-4494-8222-df6693e19386',null,null,null,'Y',null,null,null,'N','N','N',null,29,null,'自定义项14',null,'N','N','1001ZZ1LCP00000TPBHX',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def18','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def18',null,null,null,'N',null,null,'Y',null,null,120,null,'94342ea3-5b14-4b12-904b-ff2656038897',null,null,null,'Y',null,null,null,'N','N','N',null,30,null,'自定义项18',null,'N','N','1001ZZ1LCP00000TPBHY',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcdept','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcdept',null,null,null,'N',null,null,'Y',null,null,120,null,'945dcf69-6fcb-42a7-8795-62ec55ea0958',null,null,null,'N',null,null,null,'N','N','N',null,31,null,'SRC部门',null,'N','N','1001ZZ1LCP00000TPBHZ',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@',null,null,'Y','N',null,null,204,'业务单元版本(所有)','pk_org_v','9f71d037-03f1-4218-811d-d57672d4ccd3','Y',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=','pk_org_v',null,null,null,'N',null,'0001Z01000000001V046,code=N','Y',null,null,120,null,'a06fdd45-ad76-48b6-bc6c-76d504d4f4a1',null,null,null,'N',null,null,null,'N','N','N',null,32,null,'组织版本','uap.org_v.name','N','N','1001ZZ1LCP00000TPBI0',null,null,null,'Y',20,null,null,'refer','uapbd/refer/orgv/BusinessUnitVersionDefaultAllTreeRef/index',0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def6','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def6',null,null,null,'N',null,null,'Y',null,null,120,null,'a20ea04d-5cd5-434d-88d2-d213d7918659',null,null,null,'Y',null,null,null,'N','N','N',null,33,null,'自定义项6',null,'N','N','1001ZZ1LCP00000TPBI1',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcintercom','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcintercom',null,null,null,'N',null,null,'Y',null,null,120,null,'a745401b-0c14-4d36-966c-80c814721181',null,null,null,'N',null,null,null,'N','N','N',null,34,null,'SRC内部客户',null,'N','N','1001ZZ1LCP00000TPBI2',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def13','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def13',null,null,null,'N',null,null,'Y',null,null,120,null,'a9a7c062-86c3-4faa-9dae-22e9d4823714',null,null,null,'Y',null,null,null,'N','N','N',null,35,null,'自定义项13',null,'N','N','1001ZZ1LCP00000TPBI3',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipaccount','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipaccount',null,null,null,'N',null,null,'Y',null,null,120,null,'ab94387e-95a3-4025-8432-6ffa50df663d',null,null,null,'N',null,null,null,'N','N','N',null,36,null,'BIP会计科目',null,'N','N','1001ZZ1LCP00000TPBI4',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@不等于@',null,null,'Y','N',null,null,203,null,'chgmod','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@<>@','chgmod',null,null,null,'N',null,'档案转换=1,凭证转换=2','Y',null,null,120,null,'b637e4da-eb8a-4ead-9299-acba30bab3af',null,'档案转换=1,凭证转换=2',null,'N',null,null,null,'N','N','N',null,38,null,'转化模式',null,'N','N','1001ZZ1LCP00000TPBI5',null,null,null,'Y',50,null,null,'select',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcbank','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcbank',null,null,null,'N',null,null,'Y',null,null,120,null,'c4802050-7f37-4ee4-becf-a9484bdf7421',null,null,null,'N',null,null,null,'N','N','N',null,39,null,'SRC银行账户',null,'N','N','1001ZZ1LCP00000TPBI6',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def11','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def11',null,null,null,'N',null,null,'Y',null,null,120,null,'cd8ea9c5-62c1-4b1d-bc5d-2c6f864a83af',null,null,null,'Y',null,null,null,'N','N','N',null,40,null,'自定义项11',null,'N','N','1001ZZ1LCP00000TPBI7',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def17','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def17',null,null,null,'N',null,null,'Y',null,null,120,null,'d400a172-1c3d-479a-806c-dbcc6a08b5db',null,null,null,'Y',null,null,null,'N','N','N',null,41,null,'自定义项17',null,'N','N','1001ZZ1LCP00000TPBI8',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def15','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def15',null,null,null,'N',null,null,'Y',null,null,120,null,'d4b007fe-135b-49f7-935a-ede57303a5dc',null,null,null,'Y',null,null,null,'N','N','N',null,42,null,'自定义项15',null,'N','N','1001ZZ1LCP00000TPBI9',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def10','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def10',null,null,null,'N',null,null,'Y',null,null,120,null,'d69f4e5d-d3fc-4769-ac6c-90dff21e40a9',null,null,null,'Y',null,null,null,'N','N','N',null,43,null,'自定义项10',null,'N','N','1001ZZ1LCP00000TPBIA',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def16','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def16',null,null,null,'N',null,null,'Y',null,null,120,null,'db4b0b26-3517-43f3-bc7f-a17ec07665df',null,null,null,'Y',null,null,null,'N','N','N',null,44,null,'自定义项16',null,'N','N','1001ZZ1LCP00000TPBIB',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@',null,null,'Y','N',null,null,204,'用户','modifier','9f71d037-03f1-4218-811d-d57672d4ccd3','Y',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=','modifier',null,null,null,'N',null,'0001Z01000000001BVPB,code=N','Y',null,null,120,null,'dc74c670-f642-40e7-b50e-b41c9c230567',null,null,null,'N',null,null,null,'N','N','N',null,45,null,'修改人','uap.user.user_name','N','N','1001ZZ1LCP00000TPBIC',null,null,null,'Y',20,null,null,'refer','uap/refer/riart/userDefaultRefer/index',0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def20','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def20',null,null,null,'N',null,null,'Y',null,null,120,null,'e1f6bb07-7d7d-4174-9cdf-8cc052723ce3',null,null,null,'Y',null,null,null,'N','N','N',null,46,null,'自定义项20',null,'N','N','1001ZZ1LCP00000TPBID',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def1','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def1',null,null,null,'N',null,null,'Y',null,null,120,null,'e7bce856-478f-4f4f-8c28-b093549fa3aa',null,null,null,'Y',null,null,null,'N','N','N',null,47,null,'自定义项1',null,'N','N','1001ZZ1LCP00000TPBIE',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','介于@等于@大于@大于等于@小于@小于等于@',null,null,'Y','N',null,null,34,null,'creationtime','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','between@=@>@>=@<@<=@','creationtime',null,null,null,'N',null,null,'Y',null,null,120,null,'ea52bec6-d8fe-406a-ac01-3ff1f82a124a',null,null,null,'N',null,null,null,'Y','N','N',null,48,null,'创建时间',null,'N','N','1001ZZ1LCP00000TPBIF',null,null,null,'Y',19,null,null,'datetimepicker',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@',null,null,'Y','N',null,null,204,'用户','creator','9f71d037-03f1-4218-811d-d57672d4ccd3','Y',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=','creator',null,null,null,'N',null,'0001Z01000000001BVPB,code=N','Y',null,null,120,null,'edc43469-3a63-4aa3-86aa-a91b1febb7c1',null,null,null,'N',null,null,null,'N','N','N',null,49,null,'创建人','uap.user.user_name','N','N','1001ZZ1LCP00000TPBIG',null,null,null,'Y',20,null,null,'refer','uap/refer/riart/userDefaultRefer/index',0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'srcgroupcontent','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','srcgroupcontent',null,null,null,'N',null,null,'Y',null,null,120,null,'eff814d9-d6e9-40ee-a859-980ba2b06e68',null,null,null,'N',null,null,null,'N','N','N',null,50,null,'SRC组合内容',null,'N','N','1001ZZ1LCP00000TPBIH',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipintercom','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipintercom',null,null,null,'N',null,null,'Y',null,null,120,null,'f41ec5b0-c59c-40e0-95be-838fa41b1570',null,null,null,'N',null,null,null,'N','N','N',null,51,null,'BIP内部客户',null,'N','N','1001ZZ1LCP00000TPBII',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def8','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def8',null,null,null,'N',null,null,'Y',null,null,120,null,'f765144c-70ea-449d-a861-4a8bf9d5db22',null,null,null,'Y',null,null,null,'N','N','N',null,52,null,'自定义项8',null,'N','N','1001ZZ1LCP00000TPBIJ',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipvoucher','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipvoucher',null,null,null,'N',null,null,'Y',null,null,120,null,'fc73de7a-680d-40ab-bdc8-f16262a63671',null,null,null,'N',null,null,null,'N','N','N',null,53,null,'BIP凭证类别',null,'N','N','1001ZZ1LCP00000TPBIK',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','等于@包含@左包含@右包含@',null,null,'Y','N',null,null,56,null,'def9','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','=@like@left like@right like@','def9',null,null,null,'N',null,null,'Y',null,null,120,null,'fe03a221-fc14-495b-8de8-332a3ca93ba8',null,null,null,'Y',null,null,null,'N','N','N',null,54,null,'自定义项9',null,'N','N','1001ZZ1LCP00000TPBIL',null,null,null,'Y',101,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipbs','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipbs',null,null,null,'N',null,null,'Y',null,null,120,null,'fecf0ce5-14df-4925-81d9-7d8e6d2fa853',null,null,null,'N',null,null,null,'N','N','N',null,55,null,'BIP楼栋',null,'N','N','1001ZZ1LCP00000TPBIM',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_query_property ( RETURNTYPE,OPERSIGNNAME,VISIBLEPOSITION,REFCONDITION,DEFAULTSHOW,VISIBLE,DEFINE4,COLUMNNUM,DATATYPE,REFNAME,CODE,CLASSID,CONTAINLOWER,DEFINE2,SHOWFOCUS,NODELETE,ISDATAPOWERENABLE,ISNOTMETA,DATAPOWEROPERATIONCODE,SHOWTYPE,ISBEYONDORG,AREAID,OPERSIGN,METAPATH,ISGROUPPOWER,ISCONVERTTIMEZONES,ONLYLEAFCANSELECT,ISFIXEDCONDITION,RESID,DATAVAL,ISUSE,CREATOR,TABLECODE,WIDTH,ISBACKFILL,PROID,QUERYTABLENAME,SHOWDATAVAL,ANOTHERLINE,ISDEFINED,SEMANTICSOURCE,DEFAULTVALUE,ORGRIGHTS,USEFUNC,REQUIRED,DISABLED,CREATIONTIME,POSITION,DEFINE5,LABEL,METADATAPROPERTY,ISCHECK,ISMULTISELECTEDENABLED,PK_QUERY_PROPERTY,DEFINE3,DEFINE1,ISFORM,ISQUERYCONDITION,MAXLENGTH,ISRESLABEL,MOBILETITLE,ITEMTYPE,REFCODE,DR,TS ) values  ( 'refpk','包含@等于@左包含@右包含@',null,null,'Y','N',null,null,1,null,'bipaccbook','9f71d037-03f1-4218-811d-d57672d4ccd3','N',null,null,null,null,'N',null,1,'N','1001ZZ1LCP00000TPBH3','like@=@left like@right like@','bipaccbook',null,null,null,'N',null,null,'Y',null,null,120,null,'ff6259e1-6c2a-4a71-b8fd-a7f5c86287fb',null,null,null,'N',null,null,null,'N','N','N',null,56,null,'BIP账簿',null,'N','N','1001ZZ1LCP00000TPBIN',null,null,null,'Y',50,null,null,'input',null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'13023293-fdaf-48f2-b0b3-3d56c071dae4',null,null,null,null,null,null,null,null,null,null,null,null,null,'pk_group',null,'N',null,null,null,null,null,null,'uapbd/refer/org/GroupDefaultTreeRef/index',0,null,null,'N','pk_group',null,null,null,null,null,null,'3b6dd171-2900-47f3-bfbe-41e4483a2a65',null,'集团',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIO',null,null,'N',null,'集团(所有)',null,null,'N','Y',204,'uap.group.name','0001Z01000000001V008,code=N','refer',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'693c2c7c-104b-4aec-b88a-e65f49997cbd',null,null,null,null,null,null,null,null,null,null,null,null,null,'pk_org',null,'Y',null,null,null,null,null,null,'uapbd/refer/org/BusinessUnitAllTreeRef/index',1,null,null,'N','pk_org',null,null,null,null,null,null,'985be8a4-3a36-4778-8afe-2d8ed3902659',null,'组织',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIP',null,null,'N',null,'业务单元(所有)',null,null,'N','N',204,'uap.org.name','0001Z01000000001V021,code=N','refer',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'8fbe6dbd-8582-4bc2-a5f8-32c8f382d22c',null,null,null,null,null,null,null,null,null,null,null,null,null,'code',null,'Y',null,null,null,null,null,null,null,2,null,null,'N','code',null,null,null,null,null,null,null,null,'code',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIQ',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'407b5113-a309-454a-a57a-381b19ce4806',null,null,null,null,null,null,null,null,null,null,null,null,null,'name',null,'Y',null,null,null,null,null,null,null,3,null,null,'N','name',null,null,null,null,null,null,null,null,'name',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIR',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'0317ff9e-daaa-4d03-9952-00359cf2c192',null,null,null,null,null,null,null,null,null,null,null,null,null,'def12',null,'N',null,null,null,null,null,null,null,4,null,null,'Y','def12',null,null,null,null,null,null,null,null,'自定义项12',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIS',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'11aa98e0-8acd-449b-b932-219c5e012313',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipbank',null,'Y',null,null,null,null,null,null,null,5,null,null,'N','bipbank',null,null,null,null,null,null,null,null,'BIP银行账户',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIT',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'12c288f8-9334-4c69-8719-2655b2db2318',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipdept',null,'Y',null,null,null,null,null,null,null,6,null,null,'N','bipdept',null,null,null,null,null,null,null,null,'BIP部门',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIU',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'20b41540-2fde-4c6c-8eb3-490976baea3d',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcsystemname',null,'Y',null,null,null,null,null,null,null,7,null,null,'N','srcsystemname',null,null,null,null,null,null,null,null,'来源系统名称',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIV',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'247d97fc-6f02-4f28-a96d-b8446f2e37e4',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcprop',null,'Y',null,null,null,null,null,null,null,8,null,null,'N','srcprop',null,null,null,null,null,null,null,null,'SRC业态',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIW',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'291f9f81-8221-45a9-93ec-6d8046bf7906',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcproj',null,'Y',null,null,null,null,null,null,null,9,null,null,'N','srcproj',null,null,null,null,null,null,null,null,'SRC项目',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIX',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'2c9eecf6-de6c-4c80-88e8-133b73eecc44',null,null,null,null,null,null,null,null,null,null,null,null,null,'srccurrency',null,'Y',null,null,null,null,null,null,null,10,null,null,'N','srccurrency',null,null,null,null,null,null,null,null,'SRC币种',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIY',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'47930c77-017c-4171-84ca-f3edba0df8c9',null,null,null,null,null,null,null,null,null,null,null,null,null,'cdflag',null,'Y',null,null,null,null,null,null,null,11,null,null,'N','cdflag',null,null,null,null,null,null,null,null,'借贷标记',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBIZ',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'5215b6f9-c228-4984-b842-055461f3c955',null,null,null,null,null,null,null,null,null,null,null,null,null,'pk_coamap',null,'N',null,null,null,null,null,null,null,12,null,null,'N','pk_coamap',null,null,null,null,null,null,null,null,'主键',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ0',null,null,'N',null,null,null,null,'N','Y',51,null,null,'input',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'5e797308-7721-428c-823c-842ed748b200',null,null,null,null,null,null,null,null,null,null,null,null,null,'def7',null,'N',null,null,null,null,null,null,null,12,null,null,'Y','def7',null,null,null,null,null,null,null,null,'自定义项7',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ1',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'6027525f-bf3c-402b-8d47-f02af78104a7',null,null,null,null,null,null,null,null,null,null,null,null,null,'def4',null,'N',null,null,null,null,null,null,null,13,null,null,'Y','def4',null,null,null,null,null,null,null,null,'自定义项4',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ2',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'63444a46-fdc4-4770-9cf0-aa873787a5ea',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcvouchertype',null,'Y',null,null,null,null,null,null,null,14,null,null,'N','srcvouchertype',null,null,null,null,null,null,null,null,'SRC凭证类别',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ3',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'66b67a2a-a2ca-484e-88cc-695f5024c662',null,null,null,null,null,null,null,null,null,null,null,null,null,'def3',null,'N',null,null,null,null,null,null,null,15,null,null,'Y','def3',null,null,null,null,null,null,null,null,'自定义项3',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ4',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'72632d5d-ea3f-4d27-a4e9-9ac25f92b100',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcbs',null,'Y',null,null,null,null,null,null,null,16,null,null,'N','srcbs',null,null,null,null,null,null,null,null,'SRC楼栋',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ5',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'7b52f4b4-5ecf-4996-a7e4-75fde58dcbfb',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipprop',null,'Y',null,null,null,null,null,null,null,17,null,null,'N','bipprop',null,null,null,null,null,null,null,null,'BIP业态',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ6',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'81cbfbb1-304b-4e3b-b2ea-1ac9ef910f34',null,null,null,null,null,null,null,null,null,null,null,null,null,'def2',null,'N',null,null,null,null,null,null,null,18,null,null,'Y','def2',null,null,null,null,null,null,null,null,'自定义项2',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ7',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'8368ea60-a146-4b59-9798-7ed01b119bf2',null,null,null,null,null,null,null,null,null,null,null,null,null,'def19',null,'N',null,null,null,null,null,null,null,19,null,null,'Y','def19',null,null,null,null,null,null,null,null,'自定义项19',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ8',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'84c8839e-be7c-4cf9-ae34-7ed93cfad424',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipcurrency',null,'Y',null,null,null,null,null,null,null,20,null,null,'N','bipcurrency',null,null,null,null,null,null,null,null,'BIP币种',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJ9',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'89358270-b49f-49bd-9270-acc971b74617',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcinteface',null,'Y',null,null,null,null,null,null,null,21,null,null,'N','srcinteface',null,null,null,null,null,null,null,null,'来源系统接口名称',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJA',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'8da7b503-c64a-4abc-979b-5724f080543e',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipproj',null,'Y',null,null,null,null,null,null,null,22,null,null,'N','bipproj',null,null,null,null,null,null,null,null,'BIP项目',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJB',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'8e130a33-9fa0-44f7-8bf3-8f8f1b50fdf6',null,null,null,null,null,null,null,null,null,null,null,null,null,'srccompany',null,'Y',null,null,null,null,null,null,null,23,null,null,'N','srccompany',null,null,null,null,null,null,null,null,'SRC账簿',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJC',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'908a3b13-06c3-480d-90a9-f7ea857fe545',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcaccount',null,'Y',null,null,null,null,null,null,null,24,null,null,'N','srcaccount',null,null,null,null,null,null,null,null,'SRC会计科目',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJD',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'917e6587-5bdf-445a-b5bd-177e4868fa7f',null,null,null,null,null,null,null,null,null,null,null,null,null,'def5',null,'N',null,null,null,null,null,null,null,25,null,null,'Y','def5',null,null,null,null,null,null,null,null,'自定义项5',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJE',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'91a62b01-e82d-4494-8222-df6693e19386',null,null,null,null,null,null,null,null,null,null,null,null,null,'def14',null,'N',null,null,null,null,null,null,null,26,null,null,'Y','def14',null,null,null,null,null,null,null,null,'自定义项14',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJF',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'94342ea3-5b14-4b12-904b-ff2656038897',null,null,null,null,null,null,null,null,null,null,null,null,null,'def18',null,'N',null,null,null,null,null,null,null,27,null,null,'Y','def18',null,null,null,null,null,null,null,null,'自定义项18',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJG',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'945dcf69-6fcb-42a7-8795-62ec55ea0958',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcdept',null,'Y',null,null,null,null,null,null,null,28,null,null,'N','srcdept',null,null,null,null,null,null,null,null,'SRC部门',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJH',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'a20ea04d-5cd5-434d-88d2-d213d7918659',null,null,null,null,null,null,null,null,null,null,null,null,null,'def6',null,'N',null,null,null,null,null,null,null,29,null,null,'Y','def6',null,null,null,null,null,null,null,null,'自定义项6',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJI',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'a745401b-0c14-4d36-966c-80c814721181',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcintercom',null,'Y',null,null,null,null,null,null,null,30,null,null,'N','srcintercom',null,null,null,null,null,null,null,null,'SRC内部客户',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJJ',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'a9a7c062-86c3-4faa-9dae-22e9d4823714',null,null,null,null,null,null,null,null,null,null,null,null,null,'def13',null,'N',null,null,null,null,null,null,null,31,null,null,'Y','def13',null,null,null,null,null,null,null,null,'自定义项13',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJK',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'ab94387e-95a3-4025-8432-6ffa50df663d',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipaccount',null,'Y',null,null,null,null,null,null,null,32,null,null,'N','bipaccount',null,null,null,null,null,null,null,null,'BIP会计科目',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJL',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'b637e4da-eb8a-4ead-9299-acba30bab3af',null,null,null,null,null,null,null,null,null,null,null,null,null,'chgmod',null,'Y',null,null,null,null,null,null,null,33,null,null,'N','chgmod',null,null,null,null,null,null,null,null,'转化模式',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJM',null,'档案转换=1,凭证转换=2','N',null,null,null,null,'N','N',203,null,'档案转换=1,凭证转换=2','select',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'c4802050-7f37-4ee4-becf-a9484bdf7421',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcbank',null,'Y',null,null,null,null,null,null,null,34,null,null,'N','srcbank',null,null,null,null,null,null,null,null,'SRC银行账户',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJN',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'cd8ea9c5-62c1-4b1d-bc5d-2c6f864a83af',null,null,null,null,null,null,null,null,null,null,null,null,null,'def11',null,'N',null,null,null,null,null,null,null,35,null,null,'Y','def11',null,null,null,null,null,null,null,null,'自定义项11',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJO',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'d400a172-1c3d-479a-806c-dbcc6a08b5db',null,null,null,null,null,null,null,null,null,null,null,null,null,'def17',null,'N',null,null,null,null,null,null,null,36,null,null,'Y','def17',null,null,null,null,null,null,null,null,'自定义项17',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJP',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'b339f122-57d3-471e-a191-901f5c456cb5',null,null,null,null,null,null,null,null,null,null,null,null,null,'enablestate',null,'Y',null,null,null,null,null,null,null,37,null,null,'N','enablestate',null,null,null,null,null,null,null,null,'启用标记',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJQ',null,'未启用=1,已启用=2,已停用=3','N',null,null,null,null,'N','N',203,null,'未启用=1,已启用=2,已停用=3','select',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'d4b007fe-135b-49f7-935a-ede57303a5dc',null,null,null,null,null,null,null,null,null,null,null,null,null,'def15',null,'N',null,null,null,null,null,null,null,37,null,null,'Y','def15',null,null,null,null,null,null,null,null,'自定义项15',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJR',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'d69f4e5d-d3fc-4769-ac6c-90dff21e40a9',null,null,null,null,null,null,null,null,null,null,null,null,null,'def10',null,'N',null,null,null,null,null,null,null,38,null,null,'Y','def10',null,null,null,null,null,null,null,null,'自定义项10',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJS',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'db4b0b26-3517-43f3-bc7f-a17ec07665df',null,null,null,null,null,null,null,null,null,null,null,null,null,'def16',null,'N',null,null,null,null,null,null,null,39,null,null,'Y','def16',null,null,null,null,null,null,null,null,'自定义项16',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJT',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'e1f6bb07-7d7d-4174-9cdf-8cc052723ce3',null,null,null,null,null,null,null,null,null,null,null,null,null,'def20',null,'N',null,null,null,null,null,null,null,40,null,null,'Y','def20',null,null,null,null,null,null,null,null,'自定义项20',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJU',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'e7bce856-478f-4f4f-8c28-b093549fa3aa',null,null,null,null,null,null,null,null,null,null,null,null,null,'def1',null,'N',null,null,null,null,null,null,null,41,null,null,'Y','def1',null,null,null,null,null,null,null,null,'自定义项1',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJV',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'eff814d9-d6e9-40ee-a859-980ba2b06e68',null,null,null,null,null,null,null,null,null,null,null,null,null,'srcgroupcontent',null,'Y',null,null,null,null,null,null,null,42,null,null,'N','srcgroupcontent',null,null,null,null,null,null,null,null,'SRC组合内容',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJW',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'f41ec5b0-c59c-40e0-95be-838fa41b1570',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipintercom',null,'Y',null,null,null,null,null,null,null,43,null,null,'N','bipintercom',null,null,null,null,null,null,null,null,'BIP内部客户',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJX',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'f765144c-70ea-449d-a861-4a8bf9d5db22',null,null,null,null,null,null,null,null,null,null,null,null,null,'def8',null,'N',null,null,null,null,null,null,null,44,null,null,'Y','def8',null,null,null,null,null,null,null,null,'自定义项8',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJY',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'fc73de7a-680d-40ab-bdc8-f16262a63671',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipvoucher',null,'Y',null,null,null,null,null,null,null,45,null,null,'N','bipvoucher',null,null,null,null,null,null,null,null,'BIP凭证类别',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBJZ',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'fe03a221-fc14-495b-8de8-332a3ca93ba8',null,null,null,null,null,null,null,null,null,null,null,null,null,'def9',null,'N',null,null,null,null,null,null,null,46,null,null,'Y','def9',null,null,null,null,null,null,null,null,'自定义项9',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK0',null,null,'N',null,null,null,null,'N','N',56,null,null,'input',null,null,null,101,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'fecf0ce5-14df-4925-81d9-7d8e6d2fa853',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipbs',null,'Y',null,null,null,null,null,null,null,47,null,null,'N','bipbs',null,null,null,null,null,null,null,null,'BIP楼栋',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK1',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'ff6259e1-6c2a-4a71-b8fd-a7f5c86287fb',null,null,null,null,null,null,null,null,null,null,null,null,null,'bipaccbook',null,'Y',null,null,null,null,null,null,null,48,null,null,'N','bipaccbook',null,null,null,null,null,null,null,null,'BIP账簿',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK2',null,null,'N',null,null,null,null,'N','N',1,null,null,'input',null,null,null,50,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'a06fdd45-ad76-48b6-bc6c-76d504d4f4a1',null,null,null,null,null,null,null,null,null,null,null,null,null,'pk_org_v',null,'N',null,null,null,null,null,null,'uapbd/refer/orgv/BusinessUnitVersionDefaultAllTreeRef/index',49,null,null,'N','pk_org_v',null,null,null,null,null,null,'da7bba89-9a59-42d6-a262-c13ef459dbd9',null,'组织版本',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK3',null,null,'N',null,'业务单元版本(所有)',null,null,'N','N',204,'uap.org_v.name','0001Z01000000001V046,code=N','refer',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'edc43469-3a63-4aa3-86aa-a91b1febb7c1',null,null,null,null,null,null,null,null,null,null,null,null,null,'creator',null,'N',null,null,null,null,null,null,'uap/refer/riart/userDefaultRefer/index',50,null,null,'N','creator',null,null,null,null,null,null,'f6f9a473-56c0-432f-8bc7-fbf8fde54fee',null,'创建人',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK4',null,null,'Y',null,'用户',null,null,'N','Y',204,'uap.user.user_name','0001Z01000000001BVPB,code=N','refer',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'ea52bec6-d8fe-406a-ac01-3ff1f82a124a',null,null,null,null,null,null,null,null,null,null,null,null,null,'creationtime',null,'N',null,null,null,null,null,null,null,51,null,null,'N','creationtime',null,null,null,null,null,null,null,null,'创建时间',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK5',null,null,'Y',null,null,null,null,'N','N',34,null,null,'datetimepicker',null,null,null,19,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'dc74c670-f642-40e7-b50e-b41c9c230567',null,null,null,null,null,null,null,null,null,null,null,null,null,'modifier',null,'N',null,null,null,null,null,null,'uap/refer/riart/userDefaultRefer/index',52,null,null,'N','modifier',null,null,null,null,null,null,'f6f9a473-56c0-432f-8bc7-fbf8fde54fee',null,'修改人',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK6',null,null,'Y',null,'用户',null,null,'N','N',204,'uap.user.user_name','0001Z01000000001BVPB,code=N','refer',null,null,null,20,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_form_property ( ISCONVERTTIMEZONES,DEFAULTVALUE,COLOR,RESID,PROID,HYPERLINKFLAG,ISDATAPOWERENABLE,DEFINE1,SHOWASRANGE,RELATEMETA,MODIFIER,ISSYNCLIST,TEXTROWS,ISCODE,DEFINE2,ANOTHERLINE,ISBOLD,FROZEN,METAPATH,ISTOTAL,VISIBLE,CONTENTCOLOR,TABSKIP,COREINDEX,EDITFORMULA,ISNEXTROW,ISCOREDATA,REFCODE,POSITION,ALIGNMENT,ISLOCK,ISDEFINED,CODE,EDITDISABLED,ICONTYPE,DEFINE3,SHOWFORMULA,VALIDATEFORMULA,COLNUM,METAID,MULTIPLELINES,LABEL,REFCONDITION,ISSYNCSIDE,AREAID,ONLYLEAFCANSELECT,PK_FORM_PROPERTY,ISREVISE,SHOWDATAVAL,DISABLED,COLUMNNUM,REFNAME,ISGROUPPOWER,SHOWFOCUS,ISMULTISELECTEDENABLED,REQUIRED,DATATYPE,METADATAPROPERTY,DATAVAL,ITEMTYPE,CREATIONTIME,ISRESLABEL,CREATOR,MAXLENGTH,WIDTH,DEFAULTVAR,REFENTER,ISSYNCFOLD,MOBILETITLE,CLASSID,ISHIGHLIGHT,MODIFIEDTIME,DR,TS ) values  ( null,null,null,null,'2e3ea5da-88fa-4ba9-83a0-175c6078a00e',null,null,null,null,null,null,null,null,null,null,null,null,null,'modifiedtime',null,'N',null,null,null,null,null,null,null,53,null,null,'N','modifiedtime',null,null,null,null,null,null,null,null,'修改时间',null,null,'1001ZZ1LCP00000TPBH4',null,'1001ZZ1LCP00000TPBK7',null,null,'Y',null,null,null,null,'N','N',34,null,null,'datetimepicker',null,null,null,19,120,null,null,null,null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,0,null ) 
go

insert into pub_area ( TEMPLETID,TABHEADCODE,METAID,ISCLOSEQUICKQUERY,ISUNFOLD,ICONTYPE,MODIFIEDTIME,ASSOCIATEDTABLAYOUT,POSITION,RELATIONCODE,AREATYPE,RESID,MODIFIER,AREASTATUS,METASPACE,CREATIONTIME,NAME,PK_AREA,ISGRANDSON,AREAHIDE,CLAZZ,AREADESC,PAGESIZE,COLUMNNUM,ASSOCIATEDTAB,PAGINATION,CODE,MAINNESTAREACODE,METANAME,CREATOR,DR,TS ) values  ( '1001ZZ1LCP00000TPBH2',null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,null,null,'horizontal',0,null,0,null,null,'browse','gl.Coamap',null,'凭证对照关系_查询区','1001ZZ1LCP00000TPBH3','N',null,'nc.vo.gl.coamap.CoamapVO',null,null,null,null,'','CoamapQuery',null,'凭证对照关系',null,0,'2023-04-14 12:11:44' ) 
go

insert into pub_area ( TEMPLETID,TABHEADCODE,METAID,ISCLOSEQUICKQUERY,ISUNFOLD,ICONTYPE,MODIFIEDTIME,ASSOCIATEDTABLAYOUT,POSITION,RELATIONCODE,AREATYPE,RESID,MODIFIER,AREASTATUS,METASPACE,CREATIONTIME,NAME,PK_AREA,ISGRANDSON,AREAHIDE,CLAZZ,AREADESC,PAGESIZE,COLUMNNUM,ASSOCIATEDTAB,PAGINATION,CODE,MAINNESTAREACODE,METANAME,CREATOR,DR,TS ) values  ( '1001ZZ1LCP00000TPBH2',null,'9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,null,null,'horizontal',1,null,2,null,null,'browse','gl.Coamap',null,'凭证对照关系','1001ZZ1LCP00000TPBH4','N',null,'nc.vo.gl.coamap.CoamapVO',null,null,null,null,'true','CoamapTable',null,'凭证对照关系',null,0,'2023-04-14 12:11:44' ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '',null,'1001ZZ1LCP00000TPBKE',1,null,null,null,'Coamap_Add_Group',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'buttongroup','','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '新增',null,'1001ZZ1LCP00000TPBKF',2,null,null,'Coamap_Add_Group','Add',null,null,null,'1001ZZ100000000TPBGY','common','button_main',null,null,'Y',null,'general_btn','Ctrl+/','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '修改',null,'1001ZZ1LCP00000TPBKG',3,null,null,'Coamap_Add_Group','Edit',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','Alt+P','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '删除',null,'1001ZZ1LCP00000TPBKH',4,null,null,'Coamap_Add_Group','Delete',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','Ctrl+Del','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '复制',null,'1001ZZ1LCP00000TPBKI',5,null,null,null,'Copy',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','Alt+C','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '保存',null,'1001ZZ1LCP00000TPBKJ',6,null,null,null,'Save',null,null,null,'1001ZZ100000000TPBGY','common','button_main',null,null,'Y',null,'general_btn','Ctrl+S','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '取消',null,'1001ZZ1LCP00000TPBKK',7,null,null,null,'Cancel',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','Alt+Q','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '启用',null,'1001ZZ1LCP00000TPBKL',8,null,null,null,'Enable',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'divider',null,'20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '',null,'1001ZZ1LCP00000TPBKM',9,null,null,'Enable','enablestate_Group',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'buttongroup','','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '停用',null,'1001ZZ1LCP00000TPBKN',10,null,null,'enablestate_Group','Disable',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn',null,'20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '更多',null,'1001ZZ1LCP00000TPBKO',11,null,null,null,'More',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'more',null,'20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '导入',null,'1001ZZ1LCP00000TPBKP',12,null,null,'More','ImportAndExport_Group',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'buttongroup','','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '导入',null,'1001ZZ1LCP00000TPBKQ',13,null,null,'ImportAndExport_Group','Import',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','Ctrl+Alt+E','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '导出',null,'1001ZZ1LCP00000TPBKR',14,null,null,'ImportAndExport_Group','Export',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','ctrl+alt+c','20020COAMP_Coamap',null,null,0,null ) 
go

insert into sm_appbutnregister ( BTNNAME,ISKEYFUNC,PK_BTN,BTNORDER,ACTIONAREA,GROUPDIRECTION,PARENT_CODE,BTNCODE,PAGEDIMENSION,VISIBLE,DISABLED,APPID,BTNAREA,BTNCOLOR,DISPLAYAREA,PAGEAREACODE,ISENABLE,TEMPLETID,BTNTYPE,KEYBOARD,PAGECODE,BTNDESC,RESID,DR,TS ) values  ( '',null,'1001ZZ1LCP00000TPBKS',15,null,null,null,'Refresh',null,null,null,'1001ZZ100000000TPBGY','common','button_secondary',null,null,'Y',null,'general_btn','F5','20020COAMP_Coamap',null,null,0,null ) 
go

insert into excel_outputprocess ( BILLTYPE,MODULE,PK_PROCESS,PRANAME,PROCLASSNAME,TS ) values  ( 'COAMAP_20020COAMP','GL','1001ZZ1LCP00000TPBK8','凭证对照关系导出模板','nc.impl.gl.coamap.coamap.CoamapVOExcelOutputProcessor','2023-04-14 12:11:44' ) 
go

insert into excel_billprocess ( BASECLASSNAME,BILLTYPE,MODULE,PK_PROCESS,PRANAME,PROCLASSNAME,TS ) values  ( null,'COAMAP_20020COAMP','GL','1001ZZ1LCP00000TPBK9','凭证对照关系导入模板','nc.impl.gl.coamap.coamap.CoamapVOImportProcess','2023-04-14 12:11:44' ) 
go

insert into excel_translator ( MODULE,PK_TRANSLATOR,TRACLASSNAME,TRAID,TRANAME,DR,TS ) values  ( 'gl','1001ZZ1LCP00000TPBKA','nc.impl.gl.coamap.coamap.CoamapVOTranslator','999','凭证对照关系翻译器',0,'2023-04-14 12:11:44' ) 
go

insert into bd_userdefrule ( PK_USERDEFRULE,CODE,NAME,NAME2,NAME3,NAME4,NAME5,NAME6,ITEMCOUNT,PARENT_ID,SHOWORDER,RULETYPE,PK_ORG,PK_GROUP,CREATOR,CREATIONTIME,MODIFIER,MODIFIEDTIME,DATAORIGINFLAG,DR,TS ) values  ( '1001ZZ1LCP00000TPBKC','Coamap','凭证对照关系',null,null,null,null,null,20,'1001Z910000000003ZIS',null,0,null,null,null,null,null,null,0,0,'2023-04-14 12:11:45' ) 
go

insert into bd_userdefruleref ( PK_USERDEFRULE,PK_USERDEFRULEREF,REFCLASS,PREFIX,CHECKCLASS,CREATOR,CREATIONTIME,MODIFIER,MODIFIEDTIME,DATAORIGINFLAG,DR,TS ) values  ( '1001ZZ1LCP00000TPBKC','1001ZZ1LCP00000TPBKD','9f71d037-03f1-4218-811d-d57672d4ccd3',null,null,null,null,null,null,null,0,'2023-04-14 12:11:45' ) 
go

insert into bd_refinfo ( CODE,ISTREELAZYLOAD,ISNEEDPARA,ISSPECIALREF,LAYER,REFTYPE,METADATANAMESPACE,METADATATYPENAME,MOBILEREFPATH,MODULENAME,NAME,PARA1,PARA2,PARA3,PK_COUNTRY,PK_INDUSTRY,PK_REFINFO,REFCLASS,REFPATH,REFSYSTEM,RESERV1,RESERV2,RESERV3,RESID,RESIDPATH,WHEREPART,WORKFLOWCONDITIONUSEUNITORG,TS,DR ) values  ( '20020COAMP','N',null,null,null,0,'gl','Coamap',null,'gl','coamap_凭证对照关系_表参照_coamap_Coamap',null,null,null,null,null,'1001ZZ1LCP00000TPBKB',null,'gl/refer/coamap/CoamapGridRef/index',null,null,null,null,'coamap','coamap',null,null,'2023-04-14 12:11:45',0 ) 
go

insert into bd_refinfo ( CODE,ISTREELAZYLOAD,ISNEEDPARA,ISSPECIALREF,LAYER,REFTYPE,METADATANAMESPACE,METADATATYPENAME,MOBILEREFPATH,MODULENAME,NAME,PARA1,PARA2,PARA3,PK_COUNTRY,PK_INDUSTRY,PK_REFINFO,REFCLASS,REFPATH,REFSYSTEM,RESERV1,RESERV2,RESERV3,RESID,RESIDPATH,WHEREPART,WORKFLOWCONDITIONUSEUNITORG,TS,DR ) values  ( '20020COAMP','N',null,null,null,0,'gl','Coamap',null,'gl','coamap_凭证对照关系_默认表参照_coamap_Coamap',null,null,null,null,null,'1001ZZ1LCP00000TPBKT',null,'gl/refer/coamap/CoamapDefaultGridRef/index',null,null,null,null,'coamap','coamap',null,null,'2023-04-14 12:12:27',0 ) 
go

